﻿CREATE TABLE [dbo].[WorkitemSet] (
    [Id]          UNIQUEIDENTIFIER NOT NULL,
    [OwnerId]     UNIQUEIDENTIFIER NULL,
    [CreatorId]   UNIQUEIDENTIFIER NOT NULL,
    [CreateOn]    DATETIME         NOT NULL,
    [Title]       NVARCHAR (MAX)   NOT NULL,
    [Description] NVARCHAR (MAX)   NULL,
    [IsFinished]  BIT              NOT NULL,
    [FinishOn]    DATETIME         NULL,
    [Points]      INT              NOT NULL,
    [ProjectId]   UNIQUEIDENTIFIER NULL,
    [IsTrace]     BIT              NOT NULL,
    [PlanOn]      DATETIME         NULL,
    [StatusValue] INT              NOT NULL,
    [TaskId]      UNIQUEIDENTIFIER NULL,
    [UpdateOn]    DATETIME         NULL,
    [IsAvailable] BIT              NOT NULL
);

















